{"text_format":"2","workbook":"xls","n_sheets":9,"sheets":["PCE-TOTAL","PCE-ROW","PCE-UTILITIES","PCE-DESIGN","PCE-ENVIRONMENTAL","PCE-MISC","PCE-CONSTRUCTION","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":25,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"PCE-TOTAL","index":0,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,1,22,10]],"flags":["formulas_cached_only"]}
[{"$nulls":5},"COLORADO DEPARTMENT OF TRANSPORTATION"]
[]
[null,"Project Cost Estimate"]
[]
[null,"Completed by:"]
[null,"Project No:"]
[null,"Date of Estimate:"]
[null,"Estimated Date of Advertisement:"]
[]
[null,"Right of Way",{"$nulls":7},0]
[null,"Utilities",{"$nulls":7},0]
[null,"Design",{"$nulls":7},0]
[null,"Environmental",{"$nulls":7},0]
[null,"Miscellaneous",{"$nulls":7},0]
[null,"Construction",{"$nulls":7},0]
[]
[null,"TOTAL PROJECT COST ESTIMATE",{"$nulls":7},0]
[]
[]
[null,"Note: Please view the information in the specific tab below for details on the cost estimate for each area of the project. Fill out the PCE-Total tab and any phase tab that you are requesting reimbursement for. You can change personnel titles, add personnel and adjust the wages for anticipated wage rates."]

{"sheet":"PCE-ROW","index":1,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,1,49,10],[9,14,9,18],[10,14,14,18]],"flags":["formulas_cached_only"]}
[{"$nulls":5},"COLORADO DEPARTMENT OF TRANSPORTATION"]
[]
[null,"Project Cost Estimate"]
[]
[null,"Completed by:"]
[null,"Project No:"]
[null,"Date of Estimate:"]
[null,"Estimated Date of Advertisement:"]
[]
[null,"Right of Way",{"$nulls":12},"Note to PM:"]
[{"$nulls":14},"ROW phase funds are used to pay for costs associated with acquisition and relocations. It is recommended that LA's use their own funds for the ROW phase. ROW plan costs should be included in the design phase."]
[null,"Personnel Classification",null,null,null,"Est. Hours",null,"Wage",null,"Total"]
[]
[null,"Prin/Non-President",{"$nulls":5},61.1,null,0]
[null,"Project Manager",{"$nulls":5},46.37,null,0]
[null,"Senior Engineer",{"$nulls":5},45.98,null,0]
[null,"Project Engineer",{"$nulls":5},36.64,null,0]
[null,"Eng. Intern. II",{"$nulls":5},24.42,null,0]
[null,"Planner",{"$nulls":5},44.87,null,0]
[{"$nulls":9},0]
[]
[null,"Inflation (use 3% in this example):",{"$nulls":5},0.03,null,0]
[{"$nulls":7},"SUBTOTAL",null,0]
[]
[null,"Multiplier (including Fixed Fee)",{"$nulls":5},2.85,null,0]
[]
[null,"ODC (0.5 - 1.5%)",{"$nulls":5},0.01,null,0]
[{"$nulls":7},"SUBTOTAL",null,0]
[]
[null,"ROR (5-10%)",{"$nulls":5},0.05,null,0]
[]
[null,"Other (Please provide details in comment area below)",{"$nulls":7},0]
[]
[{"$nulls":7},"SUBTOTAL (RIGHT OF WAY)",null,0]
[]
[]
[]
[null,"Comments:"]

{"sheet":"PCE-UTILITIES","index":2,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,1,49,10],[9,14,9,18],[10,14,15,18]],"flags":["formulas_cached_only"]}
[{"$nulls":5},"COLORADO DEPARTMENT OF TRANSPORTATION"]
[]
[null,"Project Cost Estimate"]
[]
[null,"Completed by:"]
[null,"Project No:"]
[null,"Date of Estimate:"]
[null,"Estimated Date of Advertisement:"]
[]
[null,"Utilities",{"$nulls":12},"Note to PM:"]
[{"$nulls":14},"The utility phase should be used when the project will pay for utility relocations prior to the construction contract award.  If the utilties are relocated after the construction contract is awarded they can be paid for out of the construction phase. "]
[null,"Personnel Classification",null,null,null,"Est. Hours",null,"Wage",null,"Total"]
[]
[null,"Prin/Non-President",{"$nulls":5},61.1,null,0]
[null,"Project Manager",{"$nulls":5},46.37,null,0]
[null,"Senior Engineer",{"$nulls":5},45.98,null,0]
[null,"Project Engineer",{"$nulls":5},36.64,null,0]
[null,"Eng. Intern. II",{"$nulls":5},24.42,null,0]
[null,"Planner",{"$nulls":5},44.87,null,0]
[{"$nulls":9},0]
[]
[null,"Inflation (use 3% in this example):",{"$nulls":5},0.03,null,0]
[{"$nulls":7},"SUBTOTAL",null,0]
[]
[null,"Multiplier (including Fixed Fee)",{"$nulls":5},2.85,null,0]
[]
[null,"ODC (0.5 - 1.5%)",{"$nulls":5},0.01,null,0]
[{"$nulls":7},"SUBTOTAL",null,0]
[]
[null,"ROR (5-10%)",{"$nulls":5},0.05,null,0]
[]
[null,"Other (Please provide details in comment area below)",{"$nulls":7},100000]
[]
[{"$nulls":7},"SUBTOTAL (UTILITIES)",null,100000]
[]
[]
[]
[null,"Comments: Overhead powerline relocation and purchase of new easement."]

{"sheet":"PCE-DESIGN","index":3,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,1,49,10],[9,14,9,18],[10,14,15,18]],"flags":["formulas_cached_only"]}
[{"$nulls":5},"COLORADO DEPARTMENT OF TRANSPORTATION"]
[]
[null,"Project Cost Estimate"]
[]
[null,"Completed by:"]
[null,"Project No:"]
[null,"Date of Estimate:"]
[null,"Estimated Date of Advertisement:"]
[]
[null,"Design",{"$nulls":12},"Note to PM:"]
[{"$nulls":14},"Design phase funds are to be used for all eligible design costs including plan and design development, ROW plan completion, typical environmental work, and project management tasks during design."]
[null,"Personnel Classification",null,null,null,"Est. Hours",null,"Wage",null,"Total"]
[]
[null,"Prin/Non-President",{"$nulls":5},61.1,null,0]
[null,"Project Manager",{"$nulls":5},46.37,null,0]
[null,"Senior Engineer",{"$nulls":5},45.98,null,0]
[null,"Project Engineer",{"$nulls":5},36.64,null,0]
[null,"Eng. Intern. II",{"$nulls":5},24.42,null,0]
[null,"Planner",{"$nulls":5},44.87,null,0]
[{"$nulls":9},0]
[]
[null,"Inflation (use 3% in this example):",{"$nulls":5},0.03,null,0]
[{"$nulls":7},"SUBTOTAL",null,0]
[]
[null,"Multiplier (including Fixed Fee)",{"$nulls":5},2.85,null,0]
[]
[null,"ODC (0.5 - 1.5%)",{"$nulls":5},0.01,null,0]
[{"$nulls":7},"SUBTOTAL",null,0]
[]
[null,"ROR (5-10%)",{"$nulls":5},0.05,null,0]
[]
[null,"Other (Please provide details in comment area below)",{"$nulls":7},0]
[]
[{"$nulls":7},"SUBTOTAL (DESIGN)",null,0]
[]
[]
[]
[null,"Comments:"]

{"sheet":"PCE-ENVIRONMENTAL","index":4,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,1,49,10],[11,14,11,18],[12,14,16,18]],"flags":["formulas_cached_only"]}
[{"$nulls":5},"COLORADO DEPARTMENT OF TRANSPORTATION"]
[]
[null,"Project Cost Estimate"]
[]
[null,"Completed by:"]
[null,"Project No:"]
[null,"Date of Estimate:"]
[null,"Estimated Date of Advertisement:"]
[]
[null,"Environmental"]
[]
[null,"Personnel Classification",null,null,null,"Est. Hours",null,"Wage",null,"Total",{"$nulls":4},"Note to PM:"]
[{"$nulls":14},"Environmental phase funds are to be used on projects with very large environmental costs (projects which require an EIS). Projects that can be cleared under a catex should be paid for out of the design phase."]
[null,"Prin/Non-President",{"$nulls":5},61.1,null,0]
[null,"Project Manager",{"$nulls":5},46.37,null,0]
[null,"Senior Engineer",{"$nulls":5},45.98,null,0]
[null,"Project Engineer",{"$nulls":5},36.64,null,0]
[null,"Eng. Intern. II",{"$nulls":5},24.42,null,0]
[null,"Planner",{"$nulls":5},44.87,null,0]
[{"$nulls":9},0]
[]
[null,"Inflation (use 3% in this example):",{"$nulls":5},0.03,null,0]
[{"$nulls":7},"SUBTOTAL",null,0]
[]
[null,"Multiplier (including Fixed Fee)",{"$nulls":5},2.85,null,0]
[]
[null,"ODC (0.5 - 1.5%)",{"$nulls":5},0.01,null,0]
[{"$nulls":7},"SUBTOTAL",null,0]
[]
[null,"ROR (5-10%)",{"$nulls":5},0.05,null,0]
[]
[null,"Other (Please provide details in comment area below)",{"$nulls":7},0]
[]
[{"$nulls":7},"SUBTOTAL (ENVIRONMENTAL)",null,0]
[]
[]
[]
[null,"Comments:"]

{"sheet":"PCE-MISC","index":5,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,1,48,10],[9,14,9,18],[10,14,14,18]],"flags":["formulas_cached_only"]}
[{"$nulls":5},"COLORADO DEPARTMENT OF TRANSPORTATION"]
[]
[null,"Project Cost Estimate"]
[]
[null,"Completed by:"]
[null,"Project No:"]
[null,"Date of Estimate:"]
[null,"Estimated Date of Advertisement:"]
[]
[null,"Miscellaneous",{"$nulls":12},"Note to PM:"]
[{"$nulls":14},"Miscellaneous phase projects are typically non-infrastructure. Miscellaneous funds should be used for equipment purchases, installations, software purchase, ITS equipment, or purchase of construction materials with large lead times that need to be purchased ahead of the construction phase. "]
[null,"Personnel Classification",null,null,null,"Est. Hours",null,"Wage",null,"Total"]
[]
[null,"Prin/Non-President",{"$nulls":5},61.1,null,0]
[null,"Project Manager",{"$nulls":5},46.37,null,0]
[null,"Senior Engineer",{"$nulls":5},45.98,null,0]
[null,"Project Engineer",{"$nulls":5},36.64,null,0]
[null,"Eng. Intern. II",{"$nulls":5},24.42,null,0]
[null,"Planner",{"$nulls":5},44.87,null,0]
[{"$nulls":9},0]
[]
[null,"Inflation (use 3% in this example):",{"$nulls":5},0.03,null,0]
[{"$nulls":7},"SUBTOTAL",null,0]
[]
[null,"Multiplier (including Fixed Fee)",{"$nulls":5},2.85,null,0]
[]
[null,"ODC (0.5 - 1.5%)",{"$nulls":5},0.01,null,0]
[{"$nulls":7},"SUBTOTAL",null,0]
[]
[null,"ROR (5-10%)",{"$nulls":5},0.05,null,0]
[]
[null,"Other (Please provide details in comment area below)",{"$nulls":7},0]
[]
[{"$nulls":7},"SUBTOTAL (MISCELLANEOUS)",null,0]
[]
[]
[null,"Comments:"]

{"sheet":"PCE-CONSTRUCTION","index":6,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,1,52,10],[9,14,9,18],[10,14,14,18]],"flags":["formulas_cached_only"]}
[{"$nulls":5},"COLORADO DEPARTMENT OF TRANSPORTATION"]
[]
[null,"Project Cost Estimate"]
[]
[null,"Completed by:"]
[null,"Project No:"]
[null,"Date of Estimate:"]
[null,"Estimated Date of Advertisement:"]
[]
[null,"Construction",{"$nulls":12},"Note to PM:"]
[{"$nulls":14},"Construction phase funds are to be used for all eligible construction activites including material testing, project management services, contractor work, etc.  "]
[null,"Personnel Classification",null,null,null,"Est. Hours",null,"Wage",null,"Total"]
[]
[null,"Prin/Non-President",{"$nulls":5},61.1,null,0]
[null,"Project Manager",{"$nulls":5},46.37,null,0]
[null,"Senior Engineer",{"$nulls":5},45.98,null,0]
[null,"Project Engineer",{"$nulls":5},36.64,null,0]
[null,"Eng. Intern. II",{"$nulls":5},24.42,null,0]
[null,"Planner",{"$nulls":5},44.87,null,0]
[{"$nulls":9},0]
[]
[null,"Inflation (use 3% in this example):",{"$nulls":5},0.03,null,0]
[{"$nulls":7},"SUBTOTAL",null,0]
[]
[null,"Multiplier (including Fixed Fee)",{"$nulls":5},2.85,null,0]
[]
[null,"ODC (0.5 - 1.5%)",{"$nulls":5},0.01,null,0]
[{"$nulls":7},"SUBTOTAL",null,0]
[]
[null,"ROR (5-10%)",{"$nulls":5},0.05,null,0]
[{"$nulls":7},"SUBTOTAL",null,0]
[]
[null,"ESTIMATED CONSTRUCTION BID ITEMS",{"$nulls":7},4250000]
[]
[null,"CE AND INDIRECTS",{"$nulls":5},0.2395,null,1017875]
[]
[{"$nulls":7},"SUBTOTAL (CONSTRUCTION)",null,5267875]
[]
[]
[]
[null,"Comments:"]

{"sheet":"Sheet2","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}